Tabela PatAdditionalPermission

Definicja tabeli PatAdditionalPermission

Name

PatAdditionalPermission

Code

PatAdditionalPermission

Comment

Informacje o dodatkowym kryterium uprawniajacym (dostosowanie systemu do zarzadzenia nr 65/2017/DSOZ)


Lista kolumn tabeli PatAdditionalPermission

Name

Code

PatAdditionalPermissionID

PatAdditionalPermissionID

EpisodeID

EpisodeID

EventID

EventID

PerfServiceID

PerfServiceID

AdditionalPermissionKindID

AdditionalPermissionKindID

AdditionalPermissionKindCD

AdditionalPermissionKindCD


Kolumna PatAdditionalPermissionID tabeli PatAdditionalPermission

Definicja kolumny PatAdditionalPermissionID tabeli PatAdditionalPermission

Name

PatAdditionalPermissionID

Code

PatAdditionalPermissionID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID dodatkowego kryterium uprawniajacego


Kolumna EpisodeID tabeli PatAdditionalPermission

Definicja kolumny EpisodeID tabeli PatAdditionalPermission

Name

EpisodeID

Code

EpisodeID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID epizodu


Kolumna EventID tabeli PatAdditionalPermission

Definicja kolumny EventID tabeli PatAdditionalPermission

Name

EventID

Code

EventID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID zdarzenia


Kolumna PerfServiceID tabeli PatAdditionalPermission

Definicja kolumny PerfServiceID tabeli PatAdditionalPermission

Name

PerfServiceID

Code

PerfServiceID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID zlecenia/uslugi


Kolumna AdditionalPermissionKindID tabeli PatAdditionalPermission

Definicja kolumny AdditionalPermissionKindID tabeli PatAdditionalPermission

Name

AdditionalPermissionKindID

Code

AdditionalPermissionKindID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Wartosc DictionaryValueID z tabeli DictionaryValue dla slownika DictionaryID = -620


Kolumna AdditionalPermissionKindCD tabeli PatAdditionalPermission

Definicja kolumny AdditionalPermissionKindCD tabeli PatAdditionalPermission

Name

AdditionalPermissionKindCD

Code

AdditionalPermissionKindCD

Data Type

VARCHAR2(13)

Mandatory

Yes

Comment

Kod uprawnienia


Lista kluczy tabeli PatAdditionalPermission

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli PatAdditionalPermission

Definicja klucza Identifier_1 tabeli PatAdditionalPermission

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment